# import pandas as pd
# import pymysql
# from sqlalchemy import create_engine
# # engine = create_engine('mysql+pymysql://ledao:ledao123@localhost/pandas_learn')
# Tname = 'root'
# Tpassword = 'tjx890612'
# Thost = 'localhost:3306'
# Tdatabase = 'robot_ansys'
# temp = 'mysql+pymysql://{}:{}@{}/{}'.format(Tname, Tpassword, Thost, Tdatabase)
# print(temp)
# # temp = 'mysql+pymysql://'+Tname+':'+Tpassword+'@'+Thost+'/'+Tdatabase
# print(temp)
# engine = create_engine(temp)
# conn = engine.connect()
# data = pd.read_sql_table('巡检结果表', conn)
# print(data.head(5))
# sql = 'select  识别类型,count(识别类型) from 巡检结果表 group BY 识别类型 order by count(识别类型) desc'
# df = pd.read_sql_query(sql, engine)
# print(df.head(5))
k = ['Mac', 'Mohan', 20, 'M', 2000]
# s = 'INSERT INTO EMPLOYEE(FIRST_NAME, LAST_NAME, AGE, SEX, INCOME) VALUES (%s, %s, %s, %s, %s )'%k
# print(s)
j = tuple(k)
l = 'hkdshgkds'
p =l+str(j)
print(p)
o = input('请输入文字结束！')